Create Line and Clustered Chart for Total Accidents by Time 15
Now let us create our third chart with is a Line and clustered chart for Total Accidents by Time. Please follow detailed steps below to achieve the same results.
Step 1: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. Drag and drop %HighSeverity to the Tooltips. In the Time table, click on 'Hour Extended' to add to Shared axis. (See screenshot below)
Step 2: Format Chart using the guide below
I. General
II. X axis and Y axis
III. Data colors
IV. Data labels, Shapes, Background, and Shadow
V. Title
Step 3: Now we need to sort the Hour extended in order. To do this, click on the ellipses (more options) on the chart. Click on Sort ascending. Go to 'Sort by; then click on 'Hours Extended'. (See GIF below)